Work on Live projects
200+ Hours
Hands on Training
50+ Hours
Projects & Exercices
100% Placement Guarantee
Program Highlights
Dedicated career services
Resume & interview preps with industry experts & exclusive job board
Learn from the best
Award winning faculties in Data Analytics domain from top IT background.
Structured program with dedicated support
Dedicated program manager to ensure that students make progress and have learning outcomes
Hands on learning
Become job-ready by applying what you learn and build real-life projects in Data Analytics and Data Science
Ready to Get Best Data Analytics Training with Creating Minds?
A Data Analyst’s job is an asset for every firm and organization to make future judgments based on current patterns. In India, data analytics are in huge demand, and the employment rate is increasing.
Learn by Doing
Hands-On Learning: Emphasizes practical experience over theoretical knowledge.
Project-Centric Approach: Learning is centered around real-world projects.
Real-World Relevance: Projects mirror industry scenarios for practical relevance.
100% Placement Guarantee
Industry-Ready Training: Current curriculum ensures graduates meet industry demands.
Personalized Guidance: Tailored career counseling aligns students with IT job opportunities.
Top Performer Recognition: Rewards excellence, offering direct hiring into EpicMinds IT for standout students.
CURRICULUM
Module 1: Power Query (ETL+M)
- Introduction to Power Query
- Review of Data Sources/Connectors
- Basic Transforms:
- Filter, Sort, Remove/Rearrange Columns
- Add Calculated Columns
- Group By
- Split Columns (to Columns, to Rows)
- Merge Columns
- Merge Tables (Joins – Outer, Inner, Anti, Full, Cross)
- Append Tables (Union/Consolidation)
- Normalize Data (Replace, Clean, Trim, Fill Up/Down)
- Deep Dive into the “M” Language
- Creating Custom Functions using M
- Parametric Queries
- Data Consolidator:
- Universal Data Consolidator (csv, Excel, PDF)
- Web Crawling/Scraping
- Complex Transforms:
- UnPivot (Simple, Nested Columns, Delimited List)
- Pivot
- Transpose
- Stacked Tables (Equal, Unequal)
- Merging Rows (with Delimiter) and Splitting to Rows
- Allocation, Group By Local
- Entity Extractions
- Fuzzy Transforms (Merge, Group, Add Cluster Column)
- Error Handling
- Optimization (Speedup queries), Query Diagnostics
Module 2: Power Pivot (Data Modeling)
- Introduction to Data Modeling and DAX
- Understanding Facts and Dimensions
- Need for Disconnected Tables
- Understanding Relationships
- Introduction to DAX Measures
- Introduction to Calculated Columns
- Difference between Implicit v/s Explicit Measures
- Understanding how Data is stored in the Vertipaq Engine (Run Length Encoding, Value Encoding, Dictionary encoding)
- DAX (Data Analysis Expression):
- Understanding Filter Propagation
- Filter Context, Row Context, Context Transition, Expanded Tables
- Simple Measures Based on:
- X-FUNCTIONS() – SUMX, COUNTX… CONCATENATEX
- SUMMARIZE(), ADDCOLUMNS(), SUMMARIZECOLUMNS()
- TIME INTELLIGENT FUNCTIONS
- VALUES(), DISTINCT()
- Using Variables (VAR, RETURN)
- Complex Models:
- Multi-Facts – Same and Different Graduality
- Weak Relationships, USERELATIONSHIP()
- Many-to-Many Relations
- Ambiguity in Bi-Directional Relationships
- DAX – As a Query Language:
- EVALUATE
- SELECTCOLUMNS()
- FILTER / CALCULATETABLE
- SUMMARIZE / ADDCOLUMNS
- CROSSJOIN
- ORDERBY
- Optimization:
- Understanding Server Timings, Query Plans – Using DAX Studio
Module 3: Data Visualization
- Introduction to Power BI Desktop and Service
- Importing Queries and the Data Model from Excel into Power BI Desktop
- Best Practices for Visualization – choosing the right visual
- Create a Complete Dashboard/Report:
- Using Built-In + Custom Visuals
- Create Bookmarks, Custom Tooltip Pages, Drill Through & Detail Pages
- Use AI / ML based features/visuals
- Implement Dynamic RLS (Row Level Security), OLS (Object level Security) and Share Reports and Collaborate
- Implement Scheduled Refresh-requires a Gateway installed
- Implement Incremental Refresh / Query Folding
- Direct Query, Composite Models 1.0, Aggregations-requires DB Connectivity
- Create Composite Models 2.0 (Over Models published on the Service)
- Connect to the Data model in Power BI Desktop /Service from Excel
- Publish Excel workbooks with Data Models to the Service
- Understanding DataFlows (PQ in a browser – requires PPU/Premium Cap.)
- Overview of Microsoft Fabric
FAQ
Who are Creating Minds?
Creating Minds is a platform to learn and develop skills that you need for your excellent career. We help you crack your dream job by supercharging your skillsets. With our world-class mentorship and new-age curriculum, we enable you to get placed in your dream companies worldwide.
What makes the Data Analytics course unique at Creating Minds?
Our Data Analytics course at Creating Minds stands out with its new-age curriculum and world-class mentorship. We focus on supercharging your skills to help you crack your dream job in the field.
How will the course benefit my career in Data Analytics?
The course is designed to equip you with the essential skills needed for a successful career in Data Analytics. Through practical learning and mentorship, we prepare you to excel in the industry and secure placements in your dream companies globally.
Tell me more about the mentorship provided in the course.
Our world-class mentorship is tailored to guide you through the intricacies of Data Analytics. Mentors are industry experts who provide insights, career advice, and support to enhance your learning journey.
How does Creating Minds help in job placement?
Creating Minds is committed to helping you land your dream job. Through our comprehensive curriculum and mentorship, we prepare you for the job market, and our placement assistance ensures you have the skills and confidence to secure opportunities worldwide.
Is the course suitable for beginners in Data Analytics?
Absolutely! Our course caters to all levels, including beginners. The curriculum is structured to accommodate learners with varying levels of expertise, providing a solid foundation for those new to Data Analytics.
Transformative Power BI Data Analytics Course: Learn by Doing, Master by Project-based Learning
Power BI – Data Analytics course was a game-changer! Learning by doing with real projects made analytics practical. Teamwork, critical thinking, and creativity were key takeaways. Job-ready skills in Power BI? Absolutely. Highly recommended!
John, Student
