CERTIFICATIONS | Priyanka

SQL for Data Science

This course delved into fundamental topics such as Data Manipulation, Retrieval, Subqueries, Joins, and common operators, elucidating techniques to amalgamate data effectively through joins. Additionally, it provided insights into utilizing case statements and introduced concepts like data governance and profiling.
Through this course, I gained a comprehensive understanding of data structure, meaning, and interrelationships, empowering me to wield SQL proficiently for targeted analytical purposes.
A highlight was working on a project centered around Yelp reviews, where I meticulously analyzed the dataset, applying various workflows. This hands-on experience not only reinforced my analytical skills but also allowed me to step into the shoes of a real-world data scientist, enriching my perspective on data analysis.

I developed interactive dashboards and acquired proficiency in various types of joins, comprehending their functionality within datasets.
In addition, I mastered the creation of table calculations and calculated fields, seamlessly blending them for insightful analysis.
Further, I delved into the concepts of aggregation, granularity, and level of detail, leveraging them to craft intricate data hierarchies.
By connecting Tableau to diverse datasets, including Excel and CSV files, I honed my ability to weave compelling storylines through data visualization.
Moreover, I adeptly employed techniques like data blending and extraction, enhancing my capability to manipulate and present data effectively.
Additionally, I integrated filters, quick filters, and actions into dashboards, facilitating dynamic exploration and highlighting of key insights.
Lastly, I delved into advanced data preparation methodologies, augmenting my skill set for comprehensive data analysis and visualization.