I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching. Codebasics is one of the top channels on YouTube when it comes to data science, machine learning, data structures, etc. I firmly believe that “Anyone can code” and I use analogies, simple explanations, and step-by-step storytelling to explain difficult concepts in such a way that even a high school student can understand them easily.
I’m a mechanical engineer who transitioned to a full time Data & Analytics manager in the UK & Germany by teaching myself Power BI, excel & anything else that was required to solve the problem. I have worked with complex data across Supply Chain, Sales, Marketing, Revenue Management, Finance and HR functions over the last 8 years to deliver effective solutions. To me, Analytics is an extra sensory organ that anyone can develop to become a superhuman at work. I have conducted several workshops and internal training to help non-technical people to become superhuman at work and now, really excited for this opportunity to share all that knowledge with you in this course.
Topics covered in this session,
Yes, this is already covered in the first lecture of the 4th chapter, 'Install Power BI and Load Data from MySQL Database.’
Please check the video again from 03:00.
We disabled loading the data from 'Remaining Forecast' to the data view and hence it won't be present in the relationship model. (Refer - Chapter 5 -> Power Query Best Practices -> 03:15)
The load is disabled because data from 'Remaining Forecast' is already added to the 'fact_actuals_estimate table', and it is not required to load this data separately.
(Refer Chapter 5 -> Transform Data in Power Query Editor - > ~ 03:00).
Q3. What's the difference between a snowflake and a star schema?
Because both are used in building relationships? Is it always recommended to build all the possible relationships between the facts and the dimension table or, we can also leave some relationships?
1. Please find this resource to get a clear idea about the star schema and snowflake schema: www.geeksforgeeks.org/difference-between-star-schema-and-snowflake-schema/
2. It is always recommended and best practice to spend a good time in building all the possible relationships in the Data model, as it helps to do more operations like joins, calculated formulas, etc.