
Explore the fundamentals of Microsoft Excel, from calculations and graphing to pivot tables and VBA automation, and install Excel via Microsoft 365, enabling data manipulation and visualization.
Explore the anatomy of a spreadsheet, take a UI tour of Excel, and learn about blank workbooks, sheets, ranges, and the formula bar, preparing for formulas.
Learn to print an Excel sheet in a presentable format by adjusting page layout, aligning pivot tables and charts, and managing page breaks, orientation, and margins.
Create a pie chart in Power BI to display profit by region and compare with a donut chart for part-to-whole visualization, emphasizing 3–6 category suitability and formatting.
Explore map based visualizations and geo data analysis to transform geographical data into insightful, spatially aware visuals. Learn to interpret patterns, communicate findings, and leverage real time updates for monitoring.
Learn to format Power BI maps by selecting styles, configuring legends and tooltips, and fine-tuning bubbles and borders for a polished dashboard visual.
Import an Excel file and a CSV into Power BI, transform the data in Power Query, and append the two tables to create a single 20-row, 3-column dataset.
Explore basic data transformation in the Power Query editor’s home tab, including remove columns, remove duplicates, and group by to count rows or sum sales in millions.
Meet instructor Fiza as she introduces Tableau and its role in turning vast data from transactions, social media, and sensors into valuable insights for informed decision making.
Install Tableau Desktop by visiting tableau.com, selecting Tableau Desktop in releases, and downloading the current version 2024.1.1 for Windows or Mac, then complete the setup and registration.
Explore Tableau functions to transform and enhance data visuals using basic, string, date, aggregate, and logical functions; learn to apply them in calculated fields for richer insights.
Explore Tableau functions to transform and enhance data visuals, including basic, string, date, aggregate, and logical functions, with practical examples for calculated fields and conditional logic.
Explore Tableau logical functions, including if, and, or, and else, to create calculated fields that test boolean conditions and drive insights from data.
Create a Gantt chart to show time differences between application start and end dates across categories like big budget and independent, using a date diff function in Show Me visuals.
Learn to visualize geographic data with Tableau using mapping, spatial analysis, and interactive exploration to identify optimal Chicago filming locations and inform decisions based on permit availability.
Visualize geographic data in Tableau by converting latitude and longitude into a map, add the application number to details, and enhance with color density for interactive exploration.
Explore how to format maps in Tableau by adjusting background layers, selecting map styles (normal, streets, dark, outdoors, satellite), and tuning washout and color schemes to create compelling visuals.
Create a Tableau dashboard by dragging visuals onto a canvas, adjust size and layout, add text and containers, and prepare for interactive KPIs and sharing.
Connect two csv files in Tableau Desktop, build a two-table relationship on place and country, create an interactive metric map, and filter by month to compare average ratings by country.
Learn to create and apply map filters across your data source, configure month, seat type, traveler type, and continent, and customize tooltips while incorporating review counts.
Build an interactive dashboard with map visuals and tooltips to reveal average ratings, review counts, and category metrics, using drag-and-drop steps to configure summary KPIs.
Learn to arrange summary metrics in a horizontal layout, adjust formatting and decimals, build visuals by month and traveler type, and assemble an interactive dashboard.
Publish your Tableau dashboard to Tableau Cloud directly from Tableau Desktop, sharing real-time visuals and filters with teammates and stakeholders via a shareable link.
Course Description
Welcome to an exhilarating journey into the world of data mastery with our combined Excel, Power BI, and Tableau course! This comprehensive program is designed to transform data into a canvas for creativity and insight, equipping you with the skills to harness the power of these three essential tools. Through interactive learning experiences, expert guidance, and real-world applications, you'll evolve from a novice to a proficient data maestro.
Embark on this exciting adventure where Excel, Power BI, and Tableau become your trusted allies in the quest for data-driven decision-making. Whether you're a professional seeking to enhance your data analysis capabilities, a manager looking to make informed decisions, or an individual aiming to acquire in-demand skills for career advancement, this course is your gateway to mastering data visualization, analysis, and reporting.
What You'll Learn:
Introduction to Data Analysis
Understanding the importance of data-driven decision-making
Excel Mastery
Functions and formulas
Data entry and manipulation
Data validation and cleaning techniques
PivotTables and Pivot Charts for data analysis
Power BI Proficiency
Introduction to Power BI and its components
Data importing from various sources
Data modeling and transformation
Creating relationships between datasets
Building interactive dashboards and reports
Sharing and collaborating on Power BI projects
Tableau Fundamentals
Installation and setup
Data importing and preparation
Basic and advanced functions: string, date, aggregate, logical
Mastering visualizations: creating diverse and dynamic visuals
Geographic mapping and geo data visualization
End-to-End Project Implementation
Comprehensive project integrating ETL (Extract, Transform, Load) processes
Mastering Data Publication and Collaboration
Publishing to Tableau Cloud and collaborating on Tableau projects
Who Should Enroll:
Professionals seeking to enhance their data analysis and reporting skills
Business analysts, data analysts, and BI professionals looking to streamline workflows and improve efficiency
Managers and decision-makers aiming to make data-driven decisions using Excel, Power BI, and Tableau
Students and individuals interested in acquiring in-demand skills for career advancement
Prerequisites:
No prior experience with Microsoft Excel, Power BI, or Tableau is required, but basic computer literacy and a fundamental understanding of data analysis concepts will be beneficial.
What You'll Gain:
A solid understanding of Excel, Power BI, and Tableau fundamentals
Proficiency in performing data analysis, visualization, and reporting tasks using these tools
Skills to manipulate and clean datasets efficiently
Ability to create interactive dashboards and reports for effective data presentation
Enhanced storytelling skills to convey insights and influence decision-making
Confidence to leverage Excel, Power BI, and Tableau to tackle real-world data challenges
A certificate of completion recognizing your achievement in mastering these essential data tools