Site engineer, DK Group, Nashik
Service Manager (Mahindra Power Genset)
Accountant, Unicorp utilities strainers PVT LTD, Mumbai
Production Planner And Analyst
Cluster Manager - Operations
Best course for learning Power BI for any Beginner/Experienced.
I just wanted to say one thing about this unique course, you can learn Power BI from many places but you cannot gain the real industry experience that this course provides (like Product Owner discussions, taking help of Senior Data Analyst & Stakeholder meetings etc). It also helped me alot in my current organisation especially in using some advanced DAX calculations.
And finally, don't even think twice before taking this course. It's top class..........
Data Analyst
I highly recommend this course. Sir Dhaval and he's team did a great job in preparing this course. The way industry terminology are presented in a comic pattern helps even a newbie to understand financial analytics in business, domain knowledge and effective communication to stakeholders through engaging story telling via visualization.
Warehouse Management Professional
Had a great learning experience, this was my 2nd course after SQL. This course covers all the basic to advanced topics. Dhaval sir really makes every topic easily understandable and all those stakeholder meetings and discussions with Hemanand sir are really helpful, it's helpful for a beginner on how should we proceed with problems and what should be our thought process.
Technical Functional Consultant
I love the way of teaching. Every aspect is covered in best manner. completing a project from the scratch gives you very good understanding of almost all the features of Power BI.
Good luck and keep the good work going.
Head Business Development
This Power BI course has transformed my understanding of real-life business use cases. The project was a comprehensive end-to-end journey, and I was able to learn how to prioritize key stakeholders' requests and how to effectively apply various DAX formulas to solve real-world problems. The project provided a hands-on learning experience that has equipped me with the skills and knowledge to confidently use Power BI for future projects. I highly recommend this project to anyone looking to further their skills in Power BI and data analysis. Thank you for this amazing opportunity!
100 Lectures | 17hr : 24min
9 Lectures
Problem Statement
The Email that Started this Project
Project Kick-off Meeting
Learn how a ‘Project Charter’ is Used in Companies
Project Kick-off: Session Debrief
Senior Data Analyst Sets Up the Next Steps with Junior Data Analyst
Simplified: Profit and Loss Statement
Chapter Summary
Quiz
11 Lectures
Power Query or DAX for Generating Calculated Columns?
Data Modelling: Star and Snowflake Schema
Data Modeling: Connect Dimensions with Fact Tables
Simplified: Why Do We Need Dimension Tables?
Mentor Talk: Congratulations! You are Levelling Up!
Create Calculated Columns Using DAX
Easy Way to Verify Your Numbers in Power BI
Optimize Report and Reduce File Size by 25 %
I Need a Favour
Chapter Summary
Quiz
15 Lectures
Finance View: Prepare a List of Metrics
Simplified: Calculate Function & Filter Context
Finance View: Creating Metrics
Finance View: Create P&L Table Structure
Finance View: Create Last Year (LY) Column
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - I
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - II
Finance View: Create ‘Quarters’ & ‘YTD/YTG’ Slicers
Mentor Talk: Figuring Out Solutions
Finance View: Create a Line chart to Show Performance Over Time
Finance View: Build Top Product, Market & Region Visuals
Intermediate Review: I Met Product Owner Nick and He Gave this Feedback!
Finance View: Add Net Profit
Chapter Summary
Quiz
10 Lectures
Review Sales View Mockup
Sales View: Build Top Customers & Performance Matrix Visuals
Sales View: Build Product Performance & Unit Economics Visuals
Build Marketing View
Simplified: Supply Chain Basics
Supply Chain View: Review Mock Up
Supply Chain View: Build Key Measures
Supply Chain View: Build Visuals
Chapter Summary
Quiz
15 Lectures
Stakeholder Analysis and its Significance
Peter Recalls the Stakeholder Mapping Meeting
Stakeholder Review Meeting: How did it Go?
This is the secret to be ‘Job Ready’!
Practice Exercise: Quick Fixes
Practice Exercise: Implementing Dynamic Benchmark
Practice Exercise: Adding Dynamic Slicer to Filter Visual
Practice Exercise: Create a Toggle Button to Switch between Two Visuals
Practice Exercise: Create a Tool Tip to Show Trend
Learn: Adding Market Share Data
Practice Exercise: Create an Executive Dashboard
Learn: Performance Optimization
Learn: Fix Data Quality Issues
Chapter Summary
Quiz
11 Lectures
Solution: Quick Fixes
Solution: Implementing Dynamic Targets (Add Targets)
Solution: Implementing Dynamic Targets (Create a dynamic switch between Targets and LY)
Solution: Implementing Dynamic Targets (P & L visuals to compare Target or LY based on selection)
Solution: Adding Dynamic Slicer to Filter Visual
Solution: Create a Toggle Button to Switch between Two Visuals
Solution: Create a Tool Tip to Show Trend
Solution: Create an Executive Dashboard (KPI Visuals)
Solution: Create an Executive Dashboard (Key Insights by Subzone )
Solution: Create an Executive Dashboard (Market Share Visual & Conditional Formatting)
Solution: Create an Executive Dashboard (Final Enhancements)
We recommend learning by doing and therefore you need to have a laptop or a PC (at least 4 GB ram).
Yes, this course will certainly help because we cover the majority of the skills measured in the PL - 300 exam in this course. However, please be informed that this course focuses on Job ready aspects and not on all aspects required to clear PL - 300 exam. In addition to this course, you might need to visit the official learning material designed by Microsoft which is available for free -> https://docs.microsoft.com/en-us/certifications/exams/pl-300?tab=tab-learning-paths
Yes, the course will be upgraded periodically based on the new features in Power BI, and learners who have already bought this course will have free access to the upgrades.
We have created every lecture with a motive to explain everything in a easy to understand manner. However, in chapters 6-8 we are providing you with real time job concepts which could be more challenging than rest of the chapters. While working on these chapters you could make mistakes in steps or have some doubts. You need to commit yourself to hold patience, make efforts & diagnose the errors yourself by googling in order to become truly job ready. For any questions, that google cannot answer or if you hit a wall - we got you covered! You can join our active discord community (https://discord.com/invite/aWpq9S5qge) -> "codebasics - power - bi - data - analytics - course" channel which is a dedicated platform to iscuss & clear your doubts with fellow learners & mentors. Also at the end of the course, you can enroll in a video group discussion session which is a bonus feature of this course. We will hold those sessions as per demand and my availability. You can ask any course or career-related questions in that session.
When the error pops up - click the learn more, and it will take you to the page where you have to download the .net file. After you download it and run the file - restart the computer. You should be good after that.
Yes, you will still benefit from the concepts outside the tools that are discussed in this course such as business context, problem solving, project management tools, etc.
This is a contextual question. If you are talking about a pure visualization tool Tableau is slightly better. Data connectors, modeling and transformation features are available in both. However, factually speaking Power BI is cheaper and offers tighter integration with the Microsoft environment. Since most companies use excel & Microsoft tools they start with Power BI or move towards Power BI for seamless integration with other Microsoft tools (called as Power platform). This makes the job openings grow at a much higher rate on Power BI and Power Platform. Also, Power BI has been leading the Gartner’s magic quadrant in BI for the last few years as the industry leader.
The dataset used in this course is crafted from scratch to mimic the real business world by consolidating our years of experience. The dataset not just contains more than a million rows but also covers multiple facets of business data such as sales, finance, targets, forecasts, products, etc.
Power BI desktop works only in Windows OS. Please look into the system requirements section on this page. However, you can use a virtual machine to install and work with Power BI in other Operating systems.
Yes, this is the perfect course for anyone who has never done coding and wants to build a career in the IT/Data Analytics industry or just wants to perform better in your current job or business using data.
We have covered the core functions such as Sales, Marketing, Finance, and Supply Chain with their fundamentals related to this course. The domain you will learn in this course is consumer goods which is projected to have more openings and high data analytics requirements at least until 2030.
We got you covered. Go ahead and do the lighter version of this course which is still available on YouTube for free. If you like that course and want to learn further, this course is the perfect extension.
We created a much lighter version of this course on YouTube available for free (click this link) and many people gave us feedback that they were able to fetch jobs (see testimonials). Now this paid course is at least 5x better than the YouTube course which gives us ample confidence that you will be able to get a job. However, we want to be honest and do not want to make any impractical promises! Our guarantee is to prepare you for the job market by teaching the most relevant skills, knowledge & timeless principles good enough to fetch the job.
Absolutely, we have a section in this course explaining how you can add the learnings from this course in your resume that will appeal to the hiring team.
The only prerequisite is that you need to have a functional laptop with at least 4GB ram, internet connection and a thrill to learn data analysis.
Most of the courses available on the internet teach you how to build x & y without any business context and do not prepare you for the real business world. This course is rather an experience in which you will learn how to use Power BI & other non-technical skills to solve a real-life business problem using analytics. Here you focus on solving a business problem and in that process learn how Power BI can be used as a tool. This is how you will do the work when you start working as a data analyst/ Business analyst/ Power BI developer in the industry. This course will prepare you for not just fetching the job but, shine in it & grow further.
X (todo) hours
This course is taught through a true end-to-end project in a Consumer goods company involving all the steps mimicking the real business environment, so you will learn how to execute end-to-end projects Power BI projects successfully along with the business fundamentals. You will learn a lot of extra things such as Project management tools, effective communication techniques & organizational nuances.
You receive a ‘Certificate of Completion’ signed and addressed personally by me, your guide and mentor – Dhaval Patel
Add and Share this certificate with your Resume/ CV or on your LinkedIn Profile
This course uses a project-based learning approach to teach you Python using two real-life projects (1) Hospitality domain data analysis and (2) Medical data extraction. Learning Python through projects helps you understand real-life applications of this awesome programming language. You will also have two solid projects that you can add to the resume ad you work on end-to-end implementation. Total beginners, as well as people familiar with Python, will benefit from this course.
Beginners to advanced course for those preparing for a data career (data analyst, data scientist, or data engineer). This course is carefully curated to simulate real-time organizational experience to prepare you for the current job market and at the same time provides you with an ultimate learning experience through a storytelling mode that you would see in movies.