This course shows how to use Power BI for statistical analysis of data and for building interactive dashboards that help you make better decisions. It starts with the introduction and downloading the required software, then uploading files and data into the program and working in the data editor over several parts, transforming and editing data, adding new columns, and creating relationships between data tables.
- Master statistical analysis skills using PowerPoint.
- Create professional interactive reports and dashboards.
- Understand methods for analyzing temporal and geographical data.
This course teaches you how to create interactive dashboards and analyze data with Excel. It starts with an introduction, then Pivot tables and the relationships between them, using the Slicer filter, and counting with and without repetition with Count and Distinct Count. Next you move to dashboard design in two parts, column and bar charts, navigation buttons and icons, charts for comparisons and percentages, Pareto and Combo charts, year over year changes known as YOY, and showing results as Actual Vs Target.
- Create professional dashboards using Excel.
- Analyze data using PivotTables and Power Query.
- Design interactive charts that support presentations and reports.
This course teaches data analysis and visualization with Tableau, from loading data to designing the dashboard. It starts with the introduction and downloads, then bringing data into Tableau, interpreting and editing it in two parts, combining it and exporting it. After that you design many kinds of charts: text tables, the line curve and dual line with advanced settings, grouping data with the Set tool, the dot plot, heat maps, side axes, the stacked curve, maps, the Pareto chart and the Lollipop chart. Then you create performance indicators and interactive arrows, and design the dashboard in two parts.
- Ability to analyze data using Tableau.
- Create professional visual designs like maps and charts.
- Integrate and export data effectively.
This course teaches data analysis and report building with Google Looker Studio, a free tool for showing data in interactive dashboards that help digital marketing. It starts with an introduction to the tool and how to get started, then connecting to data sources and importing data from Excel. After that you learn the charts one by one: line, bar, pie, area, scatter, waterfall, Sankey and geographic maps, then tables and scorecards for key indicators. You also learn to add images and shapes, apply filters, build a dashboard, manage multiple pages, share and publish reports, blend data from several sources, and customize Google Analytics data.
- Ability to create customized professional reports.
- Master designing interactive dashboards using advanced tools.
- Analyze data effectively to understand patterns and trends.
This course explains how to use Google Tag Manager and create web and server containers to track events and manage tags without editing your site's code. It starts with an introduction and the key terms, then creating the account and the Web Container and comparing it with the server container. Next you create a Google Analytics account and connect it to WordPress and to Google Tag Manager, and you get to know the workspace, Triggers, Variables, Preview Mode and the test tag. Then you add the Meta Pixel and track the add to cart, checkout and purchase events, and you create custom events in Google Analytics.
- Master event setup and tracking using Google Tag Manager.
- Connect containers with various systems like Google Analytics and Meta Pixel.
- Manage and analyze data to enhance digital performance.
This course teaches Google Analytics, Google's analysis tool that helps you understand how visitors interact with your website and app and evaluate the performance of your marketing campaigns. It starts with the introduction, the most important terms, access to the tool and the Admin Menu. Then you learn how to connect your website to Google Analytics, create the account, use the Setup Assistant, and create Events and conversions. Next you read the basic reports step by step, such as the acquisition report, real-time reports, the engagement report, monetization, the retention report and the technology report.
- Set up a Google Analytics GA4 account and link it successfully.
- Analyze user data and performance reports effectively.
- Apply data-driven strategies to improve performance.
