Use SQL server data tools (SSDT), SQL Server Management Studio (SSMS), and Microsoft Power BI desktop to complete this homework. Refer Baltimore city\u2019s Opendata portal or other dataset of your preference as data sources <\/p>\n
1. Develop an SSIS package to import a flat file into a database table. <\/p>\n
\u25cf Download a sample CSV dataset of your choice from https:\/\/data.baltimorecity.gov. <\/p>\n
\u25cf Use the CSV file as a data source while developing your SSIS package. <\/p>\n
\u25cf Add at least three transformation steps such as formatting data types, concatenating, splitting columns, and conditional splits in to multiple outputs.<\/p>\n
\u25cf Create a database called \u201cETL\u201d in your development instance.<\/p>\n
\u25cf Use ETL database as a destination to host the transformed data. You may use multiple tables as necessary based on the type of transformation made to the source data. <\/p>\n
\u25cf Add a step in your package that truncates the target table\/s before loading data every time the package is executed. <\/p>\n
\u25cf Deploy your package to SSIS catalogue in your development instance. <\/p>\n
\u25cf Submit the package file <\/p>\n
2. Use the dataset you imported under question 1 as a data source to develop a power BI report. <\/p>\n
\u25cf Please use only less than 10k rows. Some datasets have huge number of records and may exceed the upload limits while submitting your files. <\/p>\n
\u25cf Include at least 6 data visualizations. <\/p>\n
\u25cf Include at least three filtering options. <\/p>\n
\u25cf Configure Power BI report server.<\/p>\n
\u25cf Deploy your report to the report server. <\/p>\n
\u25cf Submit the .pbix file for the power BI report. <\/p>\n","protected":false},"excerpt":{"rendered":"
Use SQL server data tools (SSDT), SQL Server Management Studio (SSMS), and Microsoft Power BI desktop to complete this homework. Refer Baltimore city\u2019s Opendata portal or other dataset of your preference as data sources ETL Exercise: 1. Develop an SSIS package to import a flat file into a database table. \u25cf Download a sample CSV […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[65],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/42622"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=42622"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/42622\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=42622"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=42622"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=42622"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=42622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}