Python II for Power BI Users
Clean data and perform Natural Language Processing through Python's functions, algorithms and programming methods
An outline of this training course
Python is a powerful programming language that is flexible and easy to understand. It has functions, algorithmic and programming methods that allow data cleanup and natural language processing that are not present in Power BI.
In this course, we are taking your Python skills to the next level. Gaelim Holland will cover intermediate programming concepts and visuals available in Python; also, an introduction to NLP. This course spans from general program concepts such as building custom functions that allow quick transformation and data cleanup to incorporating text analysis concepts to Power BI dashboard.
Before you take this course, we recommend taking the Python I for Power BI Users course where you will learn the best practices in setting up Python to minimize conflict with Power BI.
If you are have basic Python knowledge and keen on learning what can be achieved with Python, this is a great course for you.
Python I for Power BI Users - can also be accessed through a purchase of an Enterprise DNA Membership
Details of what you will learn during this course
What you get with the course
• Resource pack
Testimonials
For a list of all courses available through Enterprise DNA view here
Your Instructor
- Innovative Data Analyst and Digital Channel Optimization Specialist with thorough knowledge of Omni channel analytics and incorporating online and offline data in funnel analysis.
- Skilled in maximizing online sales, revenue, and call-to-actions through conversion rate optimization, statistical science, and A/B testing. Deep expertise in statistical testing tools, data extraction, and data science.
- My 15 year career has allowed me to work in multiple data science roles in several industries at organizations from the startup level to Fortune 500 companies across 3 continents.
Course Curriculum
-
StartDataset and String Function Intro (20:34)
-
StartInstalling Intellisense and AutoComplete for Jupyter Notebook (4:50)
-
StartUser Defined Functions (17:05)
-
StartCreating Cleaning Functions (11:03)
-
StartVisualizing Cleaned Data (40:49)
-
StartHeatmap Dashboard (25:51)
-
StartList and For Loops (12:21)
-
StartText Analysis Intro (19:01)
-
StartText Analysis Part 2 Lemmatization (3:56)
-
StartClean Text and Word Frequency (55:28)
-
StartApplying Repeatable Code (5:40)
-
StartWord Clouds (24:28)
-
StartShaped Word Clouds (11:45)
-
StartSentiment Analysis Application (19:09)
-
StartFinal Dashboard Part 1 (42:00)
-
StartFinal Dashboard Part 2 (2:11)
Frequently Asked Questions
Passionate about empowering users of Power BI
"My goal is to teach others that you have almost unlimited analytical power when harnessing all the features in Power BI.
Through training across a number of different mediums, I've reached over 10,000 Power BI users, showing them a range of tips and tricks in Power BI development.
I'm a true believer that Power BI is the future of analysis and know individuals with the right training can now create advanced analytics in a scalable way that can have a real impact in the way insights are found and consumed within organisations."
Sam McKay, CFA - Founder & CEO, Enterprise DNA