Crafting Code Wizards: Mastering HTML, R, SQL, and Web Development

Ifedayo provided assistance to a student from the University of St. Francis in Joliet on a data engineering task. The lesson centered on refining dimension and fact table designs within SQL Server. They meticulously reviewed table schemas, primary key assignments, and data types, also troubleshooting issues related to table creation and visibility. The next lesson will focus on the property and school tables.

Ifedayo guided Aminata through an Excel lesson where they focused on data analysis using filtering and sorting functions. They also covered freezing rows and columns. Aminata gained hands-on experience applying different filter types to date, numeric, and text columns, and practiced sorting data across multiple columns. For her next lesson, Aminata plans to independently practice freezing panes and further refine her sorting and filtering skills.

Ifedayo assisted Alexa in enhancing her Excel data transformation skills. During their lesson, they utilized Power Query to convert raw data into a billing-ready format, concentrating on data cleaning, date formatting, and implementing conditional logic for service codes. Alexa's next steps involve practicing changing the data source and refreshing the query to ensure a consistent workflow.

Lea Brown and Ifedayo Owolabi engaged in a discussion about the PowerBI ecosystem, drawing distinctions between PowerBI and Excel. During their lesson, they gained practical experience by pinning visuals to construct a dashboard within the PowerBI cloud service. Recognizing the need for more comprehensive PowerBI training, they decided to dedicate upcoming lessons to Lea's final project, which heavily features the platform.

Ifedayo guided Lea through creating various visualizations in PowerBI, such as tables, clustered column charts, stacked bar charts, and donut charts. Lea actively practiced formatting these visuals, adding borders, and publishing the completed report. The next lesson will delve deeper into PowerBI, specifically focusing on the nuances of publishing reports.

No city was mentioned. Ifedayo Owolabi guided Lea Brown through a PowerBI lesson, focusing on the distinctions between reports and dashboards, data import, and various transformation techniques. They practiced on PowerBI desktop, covering column formatting, data splitting, and combining fields to create a contact name column. They plan to continue their PowerBI work in a follow-up lesson scheduled for Thursday.